Dataset statistics
| Number of variables | 12 |
|---|---|
| Number of observations | 7194164 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 713.5 MiB |
| Average record size in memory | 104.0 B |
Variable types
| Numeric | 11 |
|---|---|
| Categorical | 1 |
acceleration_y is highly correlated with acceleration_z | High correlation |
acceleration_z is highly correlated with acceleration_y | High correlation |
Accuracy is highly skewed (γ1 = 20.92819319) | Skewed |
Bearing has 588974 (8.2%) zeros | Zeros |
Speed has 1235824 (17.2%) zeros | Zeros |
Reproduction
| Analysis started | 2021-12-10 12:46:33.803935 |
|---|---|
| Analysis finished | 2021-12-10 12:58:29.680531 |
| Duration | 11 minutes and 55.88 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
bookingID
Real number (ℝ≥0)
| Distinct | 19962 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.182723734 × 1011 |
| Minimum | 0 |
|---|---|
| Maximum | 1.709396984 × 1012 |
| Zeros | 443 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 109.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 7.730941134 × 1010 |
| Q1 | 3.779571222 × 1011 |
| median | 8.074538517 × 1011 |
| Q3 | 1.25413045 × 1012 |
| 95-th percentile | 1.606317769 × 1012 |
| Maximum | 1.709396984 × 1012 |
| Range | 1.709396984 × 1012 |
| Interquartile range (IQR) | 8.761733282 × 1011 |
Descriptive statistics
| Standard deviation | 4.951463486 × 1011 |
|---|---|
| Coefficient of variation (CV) | 0.6051118976 |
| Kurtosis | -1.211616157 |
| Mean | 8.182723734 × 1011 |
| Median Absolute Deviation (MAD) | 4.294967295 × 1011 |
| Skewness | 0.07856802874 |
| Sum | 5.886785651 × 1018 |
| Variance | 2.451699066 × 1023 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 4.380866644 × 1011 | 3267 | < 0.1% |
| 1.374389535 × 1012 | 2021 | < 0.1% |
| 3.435973847 × 1010 | 1813 | < 0.1% |
| 1.108101563 × 1012 | 1804 | < 0.1% |
| 7.473243096 × 1011 | 1696 | < 0.1% |
| 1.486058684 × 1012 | 1617 | < 0.1% |
| 8.933531977 × 1011 | 1550 | < 0.1% |
| 1.3657996 × 1012 | 1472 | < 0.1% |
| 1.211180778 × 1012 | 1407 | < 0.1% |
| 1.202590845 × 1011 | 1401 | < 0.1% |
| Other values (19952) | 7176116 |
| Value | Count | Frequency (%) |
| 0 | 443 | |
| 1 | 389 | |
| 2 | 81 | < 0.1% |
| 4 | 477 | |
| 6 | 507 | |
| 7 | 436 | |
| 8 | 186 | < 0.1% |
| 10 | 170 | < 0.1% |
| 11 | 98 | < 0.1% |
| 14 | 274 |
| Value | Count | Frequency (%) |
| 1.709396984 × 1012 | 181 | < 0.1% |
| 1.709396984 × 1012 | 474 | < 0.1% |
| 1.709396984 × 1012 | 337 | < 0.1% |
| 1.709396984 × 1012 | 332 | < 0.1% |
| 1.709396984 × 1012 | 391 | < 0.1% |
| 1.709396984 × 1012 | 109 | < 0.1% |
| 1.709396984 × 1012 | 428 | < 0.1% |
| 1.709396984 × 1012 | 250 | < 0.1% |
| 1.709396984 × 1012 | 1275 | |
| 1.709396984 × 1012 | 451 | < 0.1% |
| Distinct | 38396 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.10795164 |
| Minimum | 0.75 |
|---|---|
| Maximum | 1500 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 109.8 MiB |
Quantile statistics
| Minimum | 0.75 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 3.9 |
| median | 4.162 |
| Q3 | 8 |
| 95-th percentile | 16 |
| Maximum | 1500 |
| Range | 1499.25 |
| Interquartile range (IQR) | 4.1 |
Descriptive statistics
| Standard deviation | 62.55569067 |
|---|---|
| Coefficient of variation (CV) | 6.188760385 |
| Kurtosis | 452.6193014 |
| Mean | 10.10795164 |
| Median Absolute Deviation (MAD) | 1.162 |
| Skewness | 20.92819319 |
| Sum | 72718261.78 |
| Variance | 3913.214435 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3.9 | 1294112 | |
| 3 | 890962 | |
| 4 | 845323 | |
| 10 | 566057 | 7.9% |
| 6 | 549389 | 7.6% |
| 8 | 496499 | 6.9% |
| 12 | 194376 | 2.7% |
| 16 | 179944 | 2.5% |
| 5 | 131821 | 1.8% |
| 9 | 76045 | 1.1% |
| Other values (38386) | 1969636 |
| Value | Count | Frequency (%) |
| 0.75 | 6 | < 0.1% |
| 0.8 | 27 | < 0.1% |
| 0.9 | 139 | < 0.1% |
| 1 | 336 | |
| 1.1 | 54 | < 0.1% |
| 1.2 | 125 | < 0.1% |
| 1.3 | 192 | < 0.1% |
| 1.4 | 144 | < 0.1% |
| 1.5 | 485 | |
| 1.6 | 143 | < 0.1% |
| Value | Count | Frequency (%) |
| 1500 | 63 | |
| 1497.855 | 1 | < 0.1% |
| 1497.177 | 1 | < 0.1% |
| 1489.331 | 1 | < 0.1% |
| 1487 | 29 | |
| 1486.769 | 1 | < 0.1% |
| 1485 | 2 | < 0.1% |
| 1482.418 | 1 | < 0.1% |
| 1479 | 36 | |
| 1478.243 | 1 | < 0.1% |
| Distinct | 1059499 |
|---|---|
| Distinct (%) | 14.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 165.2125067 |
| Minimum | 0 |
|---|---|
| Maximum | 359.9994812 |
| Zeros | 588974 |
| Zeros (%) | 8.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 109.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 73 |
| median | 164 |
| Q3 | 260.3179169 |
| 95-th percentile | 338 |
| Maximum | 359.9994812 |
| Range | 359.9994812 |
| Interquartile range (IQR) | 187.3179169 |
Descriptive statistics
| Standard deviation | 108.9644246 |
|---|---|
| Coefficient of variation (CV) | 0.6595410162 |
| Kurtosis | -1.230906131 |
| Mean | 165.2125067 |
| Median Absolute Deviation (MAD) | 94 |
| Skewness | 0.04111357366 |
| Sum | 1188565868 |
| Variance | 11873.24582 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 588974 | 8.2% |
| 268 | 25332 | 0.4% |
| 88 | 24413 | 0.3% |
| 119 | 24299 | 0.3% |
| 118 | 22586 | 0.3% |
| 122 | 22521 | 0.3% |
| 254 | 22339 | 0.3% |
| 267 | 21093 | 0.3% |
| 121 | 20918 | 0.3% |
| 299 | 20355 | 0.3% |
| Other values (1059489) | 6401334 |
| Value | Count | Frequency (%) |
| 0 | 588974 | |
| 0.001205474138 | 1 | < 0.1% |
| 0.001504063606 | 7 | < 0.1% |
| 0.001616671681 | 2 | < 0.1% |
| 0.002067267895 | 1 | < 0.1% |
| 0.002399995923 | 1 | < 0.1% |
| 0.002684906125 | 1 | < 0.1% |
| 0.003095075488 | 6 | < 0.1% |
| 0.003160491586 | 1 | < 0.1% |
| 0.003383740783 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 359.9994812 | 1 | < 0.1% |
| 359.9985046 | 1 | < 0.1% |
| 359.9984741 | 4 | |
| 359.9979248 | 2 | |
| 359.9973755 | 1 | < 0.1% |
| 359.9969482 | 1 | < 0.1% |
| 359.9955139 | 1 | < 0.1% |
| 359.9953308 | 1 | < 0.1% |
| 359.995 | 1 | < 0.1% |
| 359.9949036 | 2 |
acceleration_x
Real number (ℝ)
| Distinct | 990842 |
|---|---|
| Distinct (%) | 13.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.06777408473 |
| Minimum | -9.999999 |
|---|---|
| Maximum | 13.3964945 |
| Zeros | 6927 |
| Zeros (%) | 0.1% |
| Negative | 3368295 |
| Negative (%) | 46.8% |
| Memory size | 109.8 MiB |
Quantile statistics
| Minimum | -9.999999 |
|---|---|
| 5-th percentile | -1.7645805 |
| Q1 | -0.50517654 |
| median | 0.06190795898 |
| Q3 | 0.63206923 |
| 95-th percentile | 1.892 |
| Maximum | 13.3964945 |
| Range | 23.3964935 |
| Interquartile range (IQR) | 1.13724577 |
Descriptive statistics
| Standard deviation | 1.350014832 |
|---|---|
| Coefficient of variation (CV) | 19.91933697 |
| Kurtosis | 13.02719684 |
| Mean | 0.06777408473 |
| Median Absolute Deviation (MAD) | 0.568322591 |
| Skewness | 0.2185292787 |
| Sum | 487577.8805 |
| Variance | 1.822540046 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 6927 | 0.1% |
| 0.045491222 | 3736 | 0.1% |
| 0.083799616 | 3725 | 0.1% |
| 0.08140534 | 2737 | < 0.1% |
| 0.08619389 | 2647 | < 0.1% |
| 0.043096945 | 2606 | < 0.1% |
| 0.047885496 | 2597 | < 0.1% |
| 0.098165266 | 2572 | < 0.1% |
| 0.08858817 | 2569 | < 0.1% |
| 0.05027977 | 2534 | < 0.1% |
| Other values (990832) | 7161514 |
| Value | Count | Frequency (%) |
| -9.999999 | 1 | < 0.1% |
| -9.99971 | 1 | < 0.1% |
| -9.999383 | 3 | |
| -9.999032593 | 1 | < 0.1% |
| -9.998642 | 1 | < 0.1% |
| -9.998491 | 1 | < 0.1% |
| -9.998284912 | 1 | < 0.1% |
| -9.998161 | 1 | < 0.1% |
| -9.998 | 1 | < 0.1% |
| -9.997708 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 13.3964945 | 1 | |
| 12.60073118 | 1 | |
| 12.43206977 | 1 | |
| 12.40322202 | 1 | |
| 12.19356958 | 1 | |
| 12.18773802 | 1 | |
| 12.16536558 | 1 | |
| 11.60711025 | 1 | |
| 11.59716403 | 1 | |
| 11.33954875 | 1 |
| Distinct | 922232 |
|---|---|
| Distinct (%) | 12.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.457620292 |
| Minimum | -19.99507446 |
|---|---|
| Maximum | 24.939201 |
| Zeros | 166 |
| Zeros (%) | < 0.1% |
| Negative | 1868136 |
| Negative (%) | 26.0% |
| Memory size | 109.8 MiB |
Quantile statistics
| Minimum | -19.99507446 |
|---|---|
| 5-th percentile | -9.894955444 |
| Q1 | -1.925576782 |
| median | 9.088211 |
| Q3 | 9.709717 |
| 95-th percentile | 10.433931 |
| Maximum | 24.939201 |
| Range | 44.93427546 |
| Interquartile range (IQR) | 11.63529378 |
Descriptive statistics
| Standard deviation | 8.068016364 |
|---|---|
| Coefficient of variation (CV) | 1.809938002 |
| Kurtosis | -0.7401543253 |
| Mean | 4.457620292 |
| Median Absolute Deviation (MAD) | 0.850424 |
| Skewness | -1.064893748 |
| Sum | 32068851.43 |
| Variance | 65.09288805 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 9.775824 | 3816 | 0.1% |
| 9.73991 | 3808 | 0.1% |
| 9.742304 | 3802 | 0.1% |
| 9.727939 | 3781 | 0.1% |
| 9.737515 | 3779 | 0.1% |
| 9.768641 | 3731 | 0.1% |
| 9.70639 | 3713 | 0.1% |
| 9.735122 | 3711 | 0.1% |
| 9.732727 | 3700 | 0.1% |
| 9.747093 | 3698 | 0.1% |
| Other values (922222) | 7156625 |
| Value | Count | Frequency (%) |
| -19.99507446 | 1 | |
| -19.886847 | 1 | |
| -19.82250977 | 1 | |
| -19.77720032 | 1 | |
| -19.73802185 | 1 | |
| -19.73233948 | 1 | |
| -19.68299255 | 1 | |
| -19.61480408 | 1 | |
| -19.6133 | 2 | |
| -19.57009277 | 1 |
| Value | Count | Frequency (%) |
| 24.939201 | 1 | |
| 24.919613 | 1 | |
| 24.873 | 1 | |
| 24.724682 | 1 | |
| 24.663425 | 1 | |
| 24.574 | 1 | |
| 24.524597 | 1 | |
| 24.421602 | 1 | |
| 24.416815 | 1 | |
| 24.256222 | 1 |
| Distinct | 1328887 |
|---|---|
| Distinct (%) | 18.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.8896587715 |
| Minimum | -14.99623108 |
|---|---|
| Maximum | 14.999435 |
| Zeros | 2081 |
| Zeros (%) | < 0.1% |
| Negative | 2729004 |
| Negative (%) | 37.9% |
| Memory size | 109.8 MiB |
Quantile statistics
| Minimum | -14.99623108 |
|---|---|
| 5-th percentile | -4.188357544 |
| Q1 | -0.923310125 |
| median | 0.7781393 |
| Q3 | 2.7458439 |
| 95-th percentile | 6.070498065 |
| Maximum | 14.999435 |
| Range | 29.99566608 |
| Interquartile range (IQR) | 3.669154025 |
Descriptive statistics
| Standard deviation | 3.173510117 |
|---|---|
| Coefficient of variation (CV) | 3.567109344 |
| Kurtosis | 1.116102528 |
| Mean | 0.8896587715 |
| Median Absolute Deviation (MAD) | 1.823695941 |
| Skewness | 0.008618377417 |
| Sum | 6400351.106 |
| Variance | 10.07116646 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 2081 | < 0.1% |
| -0.08858817 | 1015 | < 0.1% |
| -0.05027977 | 1005 | < 0.1% |
| 1.1779832 | 854 | < 0.1% |
| 1.2905141 | 834 | < 0.1% |
| -0.9122187 | 824 | < 0.1% |
| 1.0654523 | 824 | < 0.1% |
| 1.211503 | 819 | < 0.1% |
| 0.41420954 | 817 | < 0.1% |
| 0.4932206 | 816 | < 0.1% |
| Other values (1328877) | 7184275 |
| Value | Count | Frequency (%) |
| -14.99623108 | 1 | |
| -14.98860474 | 1 | |
| -14.97888489 | 1 | |
| -14.97798767 | 1 | |
| -14.976189 | 2 | |
| -14.96423035 | 1 | |
| -14.95720215 | 1 | |
| -14.95705261 | 1 | |
| -14.95600586 | 1 | |
| -14.95555725 | 1 |
| Value | Count | Frequency (%) |
| 14.999435 | 1 | |
| 14.993759 | 1 | |
| 14.993301 | 1 | |
| 14.990555 | 1 | |
| 14.985766 | 2 | |
| 14.985657 | 1 | |
| 14.983372 | 1 | |
| 14.982316 | 1 | |
| 14.978126 | 2 | |
| 14.977915 | 1 |
gyro_x
Real number (ℝ)
| Distinct | 2039457 |
|---|---|
| Distinct (%) | 28.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -0.001738068972 |
| Minimum | -0.9998474 |
|---|---|
| Maximum | 1.311228297 |
| Zeros | 19937 |
| Zeros (%) | 0.3% |
| Negative | 3697871 |
| Negative (%) | 51.4% |
| Memory size | 109.8 MiB |
Quantile statistics
| Minimum | -0.9998474 |
|---|---|
| 5-th percentile | -0.136856839 |
| Q1 | -0.02654852027 |
| median | -0.00065484754 |
| Q3 | 0.023071289 |
| 95-th percentile | 0.13194689 |
| Maximum | 1.311228297 |
| Range | 2.311075697 |
| Interquartile range (IQR) | 0.04961980927 |
Descriptive statistics
| Standard deviation | 0.1000226227 |
|---|---|
| Coefficient of variation (CV) | -57.54813204 |
| Kurtosis | 17.42008449 |
| Mean | -0.001738068972 |
| Median Absolute Deviation (MAD) | 0.02479807354 |
| Skewness | -0.006271419179 |
| Sum | -12503.95323 |
| Variance | 0.01000452505 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 19937 | 0.3% |
| -0.0012217305 | 8225 | 0.1% |
| 0.0012217305 | 7626 | 0.1% |
| -0.002443461 | 7141 | 0.1% |
| 0.002443461 | 6615 | 0.1% |
| -0.004886922 | 5520 | 0.1% |
| 0.004886922 | 5342 | 0.1% |
| -0.0061086523 | 4686 | 0.1% |
| 0.0061086523 | 4681 | 0.1% |
| 0.008552114 | 4495 | 0.1% |
| Other values (2039447) | 7119896 |
| Value | Count | Frequency (%) |
| -0.9998474 | 1 | |
| -0.9998342965 | 1 | |
| -0.9998220459 | 1 | |
| -0.99974203 | 1 | |
| -0.9997406 | 1 | |
| -0.99971026 | 1 | |
| -0.9996948 | 1 | |
| -0.99967223 | 1 | |
| -0.9996543 | 1 | |
| -0.99965066 | 1 |
| Value | Count | Frequency (%) |
| 1.311228297 | 1 | |
| 1.165097849 | 1 | |
| 1.164402489 | 1 | |
| 1.155670763 | 1 | |
| 0.9998872934 | 1 | |
| 0.9998398 | 1 | |
| 0.9998119 | 1 | |
| 0.9997988764 | 1 | |
| 0.9997567985 | 1 | |
| 0.9996993 | 1 |
gyro_y
Real number (ℝ)
| Distinct | 2203565 |
|---|---|
| Distinct (%) | 30.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -0.000127149945 |
| Minimum | -5.9894347 |
|---|---|
| Maximum | 5.99646 |
| Zeros | 18555 |
| Zeros (%) | 0.3% |
| Negative | 3537346 |
| Negative (%) | 49.2% |
| Memory size | 109.8 MiB |
Quantile statistics
| Minimum | -5.9894347 |
|---|---|
| 5-th percentile | -0.1753217136 |
| Q1 | -0.02970117037 |
| median | 0.0002593994 |
| Q3 | 0.031083878 |
| 95-th percentile | 0.1724843434 |
| Maximum | 5.99646 |
| Range | 11.9858947 |
| Interquartile range (IQR) | 0.06078504837 |
Descriptive statistics
| Standard deviation | 0.1781302481 |
|---|---|
| Coefficient of variation (CV) | -1400.946325 |
| Kurtosis | 222.4634773 |
| Mean | -0.000127149945 |
| Median Absolute Deviation (MAD) | 0.0304012354 |
| Skewness | -0.05436814525 |
| Sum | -914.7375568 |
| Variance | 0.03173038529 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 18555 | 0.3% |
| -0.0012217305 | 7083 | 0.1% |
| 0.0012217305 | 7074 | 0.1% |
| -0.002443461 | 6287 | 0.1% |
| 0.002443461 | 6103 | 0.1% |
| -0.004886922 | 4974 | 0.1% |
| 0.004886922 | 4731 | 0.1% |
| -0.0061086523 | 4239 | 0.1% |
| 0.0061086523 | 4011 | 0.1% |
| -0.008552114 | 3968 | 0.1% |
| Other values (2203555) | 7127139 |
| Value | Count | Frequency (%) |
| -5.9894347 | 1 | |
| -5.9845304 | 1 | |
| -5.9844604 | 1 | |
| -5.9823065 | 1 | |
| -5.976064 | 1 | |
| -5.973808 | 1 | |
| -5.9728804 | 1 | |
| -5.9611077 | 1 | |
| -5.952407 | 1 | |
| -5.949878 | 1 |
| Value | Count | Frequency (%) |
| 5.99646 | 1 | |
| 5.9909887 | 1 | |
| 5.9909363 | 1 | |
| 5.9891324 | 1 | |
| 5.9860353 | 1 | |
| 5.9837646 | 1 | |
| 5.977267 | 1 | |
| 5.9770174 | 1 | |
| 5.9718714 | 1 | |
| 5.970157 | 1 |
gyro_z
Real number (ℝ)
| Distinct | 1746404 |
|---|---|
| Distinct (%) | 24.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -0.0003658102102 |
| Minimum | -6.9389644 |
|---|---|
| Maximum | 6.690163193 |
| Zeros | 22688 |
| Zeros (%) | 0.3% |
| Negative | 3602888 |
| Negative (%) | 50.1% |
| Memory size | 109.8 MiB |
Quantile statistics
| Minimum | -6.9389644 |
|---|---|
| 5-th percentile | -0.09352112 |
| Q1 | -0.018467678 |
| median | -2.4430454 × 10-5 |
| Q3 | 0.0181091 |
| 95-th percentile | 0.09188748676 |
| Maximum | 6.690163193 |
| Range | 13.62912759 |
| Interquartile range (IQR) | 0.036576778 |
Descriptive statistics
| Standard deviation | 0.102658583 |
|---|---|
| Coefficient of variation (CV) | -280.6334544 |
| Kurtosis | 396.894181 |
| Mean | -0.0003658102102 |
| Median Absolute Deviation (MAD) | 0.01830137555 |
| Skewness | -0.6651113066 |
| Sum | -2631.698645 |
| Variance | 0.01053878466 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 22688 | 0.3% |
| 0.0012217305 | 8481 | 0.1% |
| -0.0012217305 | 7925 | 0.1% |
| 0.002443461 | 7299 | 0.1% |
| -0.002443461 | 7189 | 0.1% |
| -0.004886922 | 5983 | 0.1% |
| 0.004886922 | 5914 | 0.1% |
| -0.0061086523 | 5476 | 0.1% |
| -0.008552114 | 5006 | 0.1% |
| 0.0061086523 | 4948 | 0.1% |
| Other values (1746394) | 7113255 |
| Value | Count | Frequency (%) |
| -6.9389644 | 1 | |
| -6.919204 | 1 | |
| -6.8659306 | 1 | |
| -6.809573 | 1 | |
| -6.7360487 | 1 | |
| -6.702616667 | 1 | |
| -6.696601 | 1 | |
| -6.5187855 | 1 | |
| -6.3872037 | 1 | |
| -6.354958 | 1 |
| Value | Count | Frequency (%) |
| 6.690163193 | 1 | |
| 6.6063447 | 1 | |
| 6.6058373 | 1 | |
| 6.6015024 | 1 | |
| 6.4917173 | 1 | |
| 6.428613 | 1 | |
| 6.424487 | 1 | |
| 6.390509 | 1 | |
| 6.287842 | 1 | |
| 6.143259095 | 1 |
second
Real number (ℝ≥0)
| Distinct | 6090 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 600.8619229 |
| Minimum | 0 |
|---|---|
| Maximum | 8234 |
| Zeros | 8840 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 109.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 43 |
| Q1 | 241 |
| median | 519 |
| Q3 | 861 |
| 95-th percentile | 1437 |
| Maximum | 8234 |
| Range | 8234 |
| Interquartile range (IQR) | 620 |
Descriptive statistics
| Standard deviation | 461.5591954 |
|---|---|
| Coefficient of variation (CV) | 0.7681618318 |
| Kurtosis | 8.746515994 |
| Mean | 600.8619229 |
| Median Absolute Deviation (MAD) | 303 |
| Skewness | 1.573518271 |
| Sum | 4322699215 |
| Variance | 213036.8909 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 8840 | 0.1% |
| 12 | 8526 | 0.1% |
| 8 | 8504 | 0.1% |
| 6 | 8503 | 0.1% |
| 10 | 8476 | 0.1% |
| 5 | 8449 | 0.1% |
| 2 | 8448 | 0.1% |
| 14 | 8445 | 0.1% |
| 20 | 8428 | 0.1% |
| 9 | 8422 | 0.1% |
| Other values (6080) | 7109123 |
| Value | Count | Frequency (%) |
| 0 | 8840 | |
| 1 | 8325 | |
| 2 | 8448 | |
| 3 | 8336 | |
| 4 | 8399 | |
| 5 | 8449 | |
| 6 | 8503 | |
| 7 | 8267 | |
| 8 | 8504 | |
| 9 | 8422 |
| Value | Count | Frequency (%) |
| 8234 | 1 | |
| 8233 | 1 | |
| 8232 | 1 | |
| 8230 | 1 | |
| 8228 | 1 | |
| 8223 | 1 | |
| 8219 | 1 | |
| 8216 | 1 | |
| 8215 | 1 | |
| 8213 | 1 |
| Distinct | 3103928 |
|---|---|
| Distinct (%) | 43.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.022868019 |
| Minimum | -15.47626758 |
|---|---|
| Maximum | 92.44881638 |
| Zeros | 1235824 |
| Zeros (%) | 17.2% |
| Negative | 100931 |
| Negative (%) | 1.4% |
| Memory size | 109.8 MiB |
Quantile statistics
| Minimum | -15.47626758 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1.042856475 |
| median | 7.559999943 |
| Q3 | 15.4936015 |
| 95-th percentile | 23.5031688 |
| Maximum | 92.44881638 |
| Range | 107.925084 |
| Interquartile range (IQR) | 14.45074502 |
Descriptive statistics
| Standard deviation | 8.104774683 |
|---|---|
| Coefficient of variation (CV) | 0.8982481697 |
| Kurtosis | -0.9499395382 |
| Mean | 9.022868019 |
| Median Absolute Deviation (MAD) | 7.067878723 |
| Skewness | 0.5014910725 |
| Sum | 64911992.28 |
| Variance | 65.68737267 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1235824 | 17.2% |
| -1 | 99101 | 1.4% |
| 0.5 | 4974 | 0.1% |
| 1 | 3809 | 0.1% |
| 1.5 | 2920 | < 0.1% |
| 0.25 | 2732 | < 0.1% |
| 2 | 2672 | < 0.1% |
| 0.75 | 2388 | < 0.1% |
| 2.5 | 2363 | < 0.1% |
| 1.25 | 2305 | < 0.1% |
| Other values (3103918) | 5835076 |
| Value | Count | Frequency (%) |
| -15.47626758 | 1 | |
| -15.10753315 | 1 | |
| -10.62225 | 1 | |
| -10.37766769 | 1 | |
| -10.06524783 | 1 | |
| -9.994782948 | 1 | |
| -9.872126206 | 1 | |
| -9.662187507 | 1 | |
| -9.6612475 | 1 | |
| -9.088018986 | 1 |
| Value | Count | Frequency (%) |
| 92.44881638 | 1 | |
| 82.86835987 | 1 | |
| 82.75298019 | 1 | |
| 74.45287989 | 1 | |
| 73.05714399 | 1 | |
| 66.03739991 | 1 | |
| 63.36130779 | 1 | |
| 58.50670419 | 1 | |
| 57.62191993 | 1 | |
| 57.62065404 | 1 |
label
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 109.8 MiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 0 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 5006289 | |
| 1 | 2187875 |
Length
Histogram of lengths of the category
Pie chart
| Value | Count | Frequency (%) |
| 0 | 5006289 | |
| 1 | 2187875 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
First rows
| bookingID | Accuracy | Bearing | acceleration_x | acceleration_y | acceleration_z | gyro_x | gyro_y | gyro_z | second | Speed | label | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2.748779e+11 | 9.293 | 17.000000 | 0.032775 | 8.659933 | 4.737300 | 0.024629 | 0.004028 | -0.010858 | 257.0 | 0.190000 | 1 |
| 1 | 1.632088e+11 | 10.000 | 262.184418 | 0.599490 | -9.180023 | -2.520432 | 0.026767 | -0.030687 | -0.006071 | 556.0 | 2.110000 | 0 |
| 2 | 1.632088e+11 | 3.900 | 247.000000 | -0.178970 | 9.149704 | 3.551163 | -0.006271 | -0.026047 | -0.012314 | 32.0 | 9.050000 | 1 |
| 3 | 2.920578e+11 | 4.000 | 248.000000 | 0.270553 | 3.270579 | 8.959376 | -0.009404 | 0.023554 | -0.006946 | 1008.0 | 9.497410 | 1 |
| 4 | 2.491081e+11 | 6.000 | 95.000000 | -0.152798 | 9.903376 | -0.042253 | -0.006894 | 0.063513 | 0.028047 | 518.0 | 0.048665 | 1 |
| 5 | 9.448928e+10 | 7.627 | 114.000000 | -0.509026 | 10.693520 | 1.033156 | -0.174358 | 0.034837 | 0.024662 | 1250.0 | 23.439410 | 0 |
| 6 | 8.589935e+09 | 4.000 | 352.000000 | -1.403826 | 10.184417 | -0.607811 | 0.332154 | 0.162473 | -0.033859 | 782.0 | 21.056380 | 1 |
| 7 | 4.638565e+11 | 12.000 | 73.818901 | -0.793289 | -8.862109 | -3.120071 | 0.014406 | 0.015587 | 0.003032 | 876.0 | 23.222500 | 0 |
| 8 | 1.288490e+11 | 5.002 | 0.000000 | -0.233435 | 7.514202 | 6.165070 | -0.019743 | -0.040549 | -0.049944 | 108.0 | 0.000000 | 0 |
| 9 | 5.153961e+10 | 9.648 | 105.000000 | -1.264862 | 11.337616 | 0.558929 | 0.006927 | 0.020798 | 0.010254 | 719.0 | 21.980000 | 0 |
Last rows
| bookingID | Accuracy | Bearing | acceleration_x | acceleration_y | acceleration_z | gyro_x | gyro_y | gyro_z | second | Speed | label | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7194154 | 1.133871e+12 | 6.000 | 42.000000 | 0.368362 | 12.377152 | -0.391538 | 0.026896 | 0.090635 | -0.096848 | 1404.0 | 25.385725 | 1 |
| 7194155 | 1.365800e+12 | 8.000 | 0.000000 | -0.202322 | -8.624347 | -4.963852 | -0.020651 | -0.036987 | 0.036801 | 611.0 | 28.159185 | 0 |
| 7194156 | 1.486059e+12 | 6.000 | 88.000000 | -0.196331 | 9.172467 | 3.708732 | 0.051727 | 0.012014 | -0.026304 | 1252.0 | 28.985123 | 1 |
| 7194157 | 1.589138e+12 | 6.000 | 355.000000 | 0.541106 | 8.755863 | 1.084607 | 0.048869 | -0.066584 | -0.040928 | 1062.0 | 26.868252 | 1 |
| 7194158 | 1.348620e+12 | 6.000 | 41.000000 | 0.120907 | 8.845378 | 4.498705 | 0.024435 | -0.012217 | 0.006109 | 323.0 | 25.612532 | 1 |
| 7194159 | 1.211181e+12 | 11.000 | 119.000000 | 0.716465 | 7.281964 | 2.324770 | -0.596548 | -0.030094 | 0.091613 | 541.0 | 25.250000 | 1 |
| 7194160 | 1.494649e+12 | 4.000 | 0.000000 | 0.502798 | 5.810905 | 7.515629 | 0.007295 | 0.035505 | 0.026456 | 1637.0 | 27.794693 | 1 |
| 7194161 | 1.228361e+12 | 4.964 | 272.000000 | 0.067038 | 11.405977 | 0.191536 | 0.075695 | -0.023719 | 0.054524 | 742.0 | 25.281769 | 0 |
| 7194162 | 1.511828e+12 | 7.000 | 49.703369 | 0.007925 | -8.033231 | 0.388345 | -0.050394 | 0.024747 | 0.028131 | 499.0 | 25.596136 | 0 |
| 7194163 | 1.460289e+12 | 6.000 | 246.000000 | 0.014366 | 8.281796 | 0.979258 | -0.074037 | -0.002198 | -0.041655 | 943.0 | 25.008970 | 1 |